﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="pub_info.aspx.vb" Inherits="GLOBALDATABASE.WebForm5" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" 
    DataKeyNames="pub_id" DataSourceID="SqlDataSource1">
    <Columns>
        <asp:BoundField DataField="pub_id" HeaderText="pub_id" ReadOnly="True" 
            SortExpression="pub_id" />
        <asp:BoundField DataField="pr_info" HeaderText="pr_info" 
            SortExpression="pr_info" />
    </Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConnectionString="<%$ ConnectionStrings:pubsConnectionString5 %>" 
    DeleteCommand="DELETE FROM [pub_info] WHERE [pub_id] = @pub_id" 
    InsertCommand="INSERT INTO [pub_info] ([pub_id], [logo], [pr_info]) VALUES (@pub_id, @logo, @pr_info)" 
    SelectCommand="SELECT * FROM [pub_info]" 
    UpdateCommand="UPDATE [pub_info] SET [logo] = @logo, [pr_info] = @pr_info WHERE [pub_id] = @pub_id">
    <DeleteParameters>
        <asp:Parameter Name="pub_id" Type="String" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="pub_id" Type="String" />
        <asp:Parameter Name="logo" Type="Object" />
        <asp:Parameter Name="pr_info" Type="String" />
    </InsertParameters>
    <UpdateParameters>
        <asp:Parameter Name="logo" Type="Object" />
        <asp:Parameter Name="pr_info" Type="String" />
        <asp:Parameter Name="pub_id" Type="String" />
    </UpdateParameters>
</asp:SqlDataSource>
</asp:Content>
